{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":196,"n_cols":11,"rows_kept":196,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,6,0,9],[1,6,1,9],[23,1,23,2],[42,1,42,2],[61,1,61,2],[80,1,80,2],[99,1,99,2],[118,1,118,2],[137,1,137,2],[156,1,156,2],[175,1,175,2],[194,1,194,2],[195,1,195,3]]}
[null,"МАОУ \"Троельжанская СОШ\"",null,null,"Утвердил:","должность","директор"]
[{"$nulls":5},"фамилия","Мясникова Т.А."]
[null,null,null,"12-17 лет",null,"дата",12,1,2026]
[{"$nulls":6},"день","месяц","год"]
["День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E6:E12)","v":0},0,0,0,0,null,{"$f":"SUM(K6:K12)","v":0}]
[{"$f":"A6","v":1},"Обед","закуска"]
[null,null,"1 блюдо","Суп гороховый ",250,2.3,4.25,15.13,108,144,20.67]
[null,null,"2 блюдо","Биточки из кур с соусом ",100,15,10.71,9.29,189,"412/435",61.11]
[null,null,"гарнир","Макаронные изделия отв.",180,6.79,0.8,34.85,174,291,20.99]
[null,null,"напиток","Компот из свежих фруктов ",200,0.5,0.2,23.1,96,507,14.03]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,142,108,5.23]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},825,{"$nulls":5},107.93]
[]
[null,null,"итого",null,{"$f":"SUM(E14:E22)","v":1645},31.59,15.96,122.37,761,null,{"$f":"SUM(K14:K22)","v":232.96}]
[{"$f":"A6","v":1},"Итого за день:",null,null,{"$f":"E13+E23","v":1645},31.59,15.96,122.37,761,null,{"$f":"K13+K23","v":232.96}]
[2,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E25:E31)","v":0},0,0,0,0,null,{"$f":"SUM(K25:K31)","v":0}]
[{"$f":"A25","v":2},"Обед","закуска"]
[null,null,"1 блюдо","Борщ со сметаной ",255,1.96,5.75,10.83,103,"28/479",22.41]
[null,null,"2 блюдо","Тефтели из говядины с соусом ",100,10.3,10.7,8,170,388,55.96]
[null,null,"гарнир","Картофельное пюре ",180,3.78,7.92,19.62,166,429,32.66]
[null,null,"напиток","Чай с сахаром ",200,0.1,null,15,60,493,5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,142,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},820,{"$nulls":5},107.93]
[]
[null,null,"итого",null,{"$f":"SUM(E33:E41)","v":1645},23.14,24.37,93.45,693,null,{"$f":"SUM(K33:K41)","v":232.96}]
[{"$f":"A25","v":2},"Итого за день:",null,null,{"$f":"E32+E42","v":1645},23.14,24.37,93.45,693,null,{"$f":"K32+K42","v":232.96}]
[3,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E44:E50)","v":0},0,0,0,0,null,{"$f":"SUM(K44:K50)","v":0}]
[{"$f":"A44","v":3},"Обед","закуска"]
[null,null,"1 блюдо","Суп-пюре с гренками ",260,5.98,6.56,31.72,209,"159/170",36.33]
[null,null,"2 блюдо","Кнели рыбные с соусом ",100,13.6,1.4,5.5,89,"334/435",58.13]
[null,null,"гарнир","Рис отварной ",180,4.43,7.3,40.57,246,414,19.57]
[null,null,"напиток","Чай с сахаром ",200,0,null,15,60,493,5]
[null,null,"хлеб бел.","Хлеб пшеничный ",30,2.28,0.24,14.76,71,108,3]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},825,{"$nulls":5},107.93]
[]
[null,null,"итого",null,{"$f":"SUM(E52:E60)","v":1625},28.29,15.5,117.55,727,null,{"$f":"SUM(K52:K60)","v":232.96}]
[{"$f":"A44","v":3},"Итого за день:",null,null,{"$f":"E51+E61","v":1625},28.29,15.5,117.55,727,null,{"$f":"K51+K61","v":232.96}]
[4,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E63:E69)","v":0},0,0,0,0,null,{"$f":"SUM(K63:K69)","v":0}]
[{"$f":"A63","v":4},"Обед","закуска"]
[null,null,"1 блюдо","Рассольник со сметаной",255,2.18,6,16.43,129,"134/479",23.13]
[null,null,"2 блюдо","Фрикадельки из кур с соусом ",105,14.98,13.02,7.98,209,"410/435",54.49]
[null,null,"гарнир","Каша пшенная ",180,7.85,11.58,33.41,269,258,24.38]
[null,null,"напиток","Компот из свежих фруктов ",200,0.5,0.2,23.1,96,507,14.03]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,4.56,0.48,29.52,142,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,1.98,0.36,10.02,52,109,3]
[{"$nulls":4},830,{"$nulls":5},107.93]
[]
[null,null,"итого",null,{"$f":"SUM(E71:E79)","v":1660},32.05,31.64,120.46,897,null,{"$f":"SUM(K71:K79)","v":232.96}]
[{"$f":"A63","v":4},"Итого за день:",null,null,{"$f":"E70+E80","v":1660},32.05,31.64,120.46,897,null,{"$f":"K70+K80","v":232.96}]
[5,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E82:E88)","v":0},0,0,0,0,null,{"$f":"SUM(K82:K88)","v":0}]
[{"$f":"A82","v":5},"Обед","закуска"]
[null,null,"1 блюдо","Суп с вермишелью ",250,2.58,2.78,18.55,110,158,17.8]
[null,null,"2 блюдо","Кнели из говядины с соусом ",100,16.4,13,5.6,212,"379/453",60.57]
[null,null,"гарнир","Картофельное пюре ",180,3.78,7.92,19.62,166,429,32.66]
[null,null,"напиток","Чай с сахаром ",200,0.1,null,15,60,493,5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,142,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},800,{"$nulls":5},107.93]
[]
[null,null,"итого",null,{"$f":"SUM(E90:E98)","v":1620},29.86,23.7,98.77,742,null,{"$f":"SUM(K90:K98)","v":232.96}]
[{"$f":"A82","v":5},"Итого за день:",null,null,{"$f":"E89+E99","v":1620},29.86,23.7,98.77,742,null,{"$f":"K89+K99","v":232.96}]
[1,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E101:E107)","v":0},0,0,0,0,null,{"$f":"SUM(K101:K107)","v":0}]
[{"$f":"A101","v":1},"Обед","закуска"]
[null,null,"1 блюдо","Борщ со сметаной ",255,1.96,5.75,10.83,103,"28/479",22.41]
[null,null,"2 блюдо","Биточки из говядины с соусом ",100,17.8,17.5,14.3,286,"381/435",67.63]
[null,null,"гарнир","Макаронные изделия отв.",180,6.79,0.8,34.85,174,291,20.99]
[null,null,"напиток","Чай с сахаром ",200,0,null,15,60,493,5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,142,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},825,{"$nulls":5},107.93]
[]
[null,null,"итого",null,{"$f":"SUM(E109:E117)","v":1650},33.55,24.05,114.98,817,null,{"$f":"SUM(K109:K117)","v":232.96}]
[{"$f":"A101","v":1},"Итого за день:",null,null,{"$f":"E108+E118","v":1650},33.55,24.05,114.98,817,null,{"$f":"K108+K118","v":232.96}]
[2,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E120:E126)","v":0},0,0,0,0,null,{"$f":"SUM(K120:K126)","v":0}]
[{"$f":"A120","v":2},"Обед","закуска"]
[null,null,"1 блюдо","Суп гороховый ",250,2.3,4.25,15.13,108,144,20.67]
[null,null,"2 блюдо","Рыба,тушенная с овощами ",100,9.5,5.14,4.5,102,343,47.2]
[null,null,"гарнир","Картофельное пюре ",180,4,8,20,166,429,32.66]
[null,null,"напиток","Компот из смеси сухофруктов ",200,0.5,null,27,110,508,15.5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,142,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},830,{"$nulls":5},107.93]
[]
[null,null,"итого",null,{"$f":"SUM(E128:E136)","v":1650},23.3,17.39,106.63,680,null,{"$f":"SUM(K128:K136)","v":232.96}]
[{"$f":"A120","v":2},"Итого за день:",null,null,{"$f":"E127+E137","v":1650},23.3,17.39,106.63,680,null,{"$f":"K127+K137","v":232.96}]
[3,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E139:E145)","v":0},0,0,0,0,null,{"$f":"SUM(K139:K145)","v":0}]
[{"$f":"A139","v":3},"Обед","закуска"]
[null,null,"1 блюдо","Щи из капусты со сметаной ",255,1.88,5.73,7.96,91,"142/479",17.8]
[null,null,"2 блюдо","Кнели из кур с соусом ",100,17.29,17.57,7.43,256,"411/435",66.69]
[null,null,"гарнир","Каша гречневая ",180,10.26,9.41,44.5,304,237,21.83]
[null,null,"напиток","Напиток из шиповника ",200,0.7,0.3,22.8,97,519,9.71]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,4.56,0,29.52,141,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},830,{"$nulls":5},107.93]
[]
[null,null,"итого",null,{"$f":"SUM(E147:E155)","v":1655},36.69,33.01,122.21,941,null,{"$f":"SUM(K147:K155)","v":232.96}]
[{"$f":"A139","v":3},"Итого за день:",null,null,{"$f":"E146+E156","v":1655},36.69,33.01,122.21,941,null,{"$f":"K146+K156","v":232.96}]
[4,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E158:E164)","v":0},0,0,0,0,null,{"$f":"SUM(K158:K164)","v":0}]
[{"$f":"A158","v":4},"Обед","закуска"]
[null,null,"1 блюдо","Суп крестьянский со сметаной ",255,2.3,4.25,15.13,108,"154/479",18.28]
[null,null,"2 блюдо","Шницели из говядины с соусом ",100,17.8,17.5,14.3,286,"381/453",62.83]
[null,null,"гарнир","Каша ячневая ",180,5.76,10.26,32.18,244,255,25.21]
[null,null,"напиток","Напиток из шиповника ",200,1,0,23,97,519,9.71]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,141,108,6]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},800,{"$nulls":5},107.93]
[]
[null,null,"итого",null,{"$f":"SUM(E166:E174)","v":1625},33.86,32.01,124.61,928,null,{"$f":"SUM(K166:K174)","v":232.96}]
[{"$f":"A158","v":4},"Итого за день:",null,null,{"$f":"E165+E175","v":1625},33.86,32.01,124.61,928,null,{"$f":"K165+K175","v":232.96}]
[5,"Завтрак","гор.блюдо"]
[]
[null,null,"гор.напиток"]
[null,null,"хлеб"]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E177:E183)","v":0},0,0,0,0,null,{"$f":"SUM(K177:K183)","v":0}]
[{"$f":"A177","v":5},"Обед","закуска"]
[null,null,"1 блюдо","Суп-пюре с гренками ",270,7.1,6.68,38.7,243,"159/170",38.2]
[null,null,"2 блюдо","Фрикадельки из кур с соусом ",105,15,13,8,209,"410/435",54.49]
[null,null,"гарнир","Рис отварной ",180,4.43,7.3,40.57,246,414,19.57]
[null,null,"напиток","Чай с сахаром ",200,0.1,null,15,60,493,5]
[null,null,"хлеб бел.","Хлеб пшеничный ",60,5,0,30,141,108,4.77]
[null,null,"хлеб черн.","Хлеб ржаной ",30,2,0,10,52,109,3]
[{"$nulls":4},825,{"$nulls":5},107.93]
[]
[null,null,"итого",null,{"$f":"SUM(E185:E193)","v":1670},33.63,26.98,142.27,951,null,{"$f":"SUM(K185:K193)","v":232.96}]
[{"$f":"A177","v":5},"Итого за день:",null,null,{"$f":"E184+E194","v":1670},33.63,26.98,142.27,951,null,{"$f":"K184+K194","v":232.96}]
[null,"Среднее значение за период:",null,null,{"$f":"(E24+E43+E62+E81+E100+E119+E138+E157+E176+E195)/(IF(E24=0,0,1)+IF(E43=0,0,1)+IF(E62=0,0,1)+IF(E81=0,0,1)+IF(E100=0,0,1)+IF(E119=0,0,1)+IF(E138=0,0,1)+IF(E157=0,0,1)+IF(E176=0,0,1)+IF(E195=0,0,1))","v":1644.5},30.596,24.461,116.33,813.7,null,{"$f":"(K24+K43+K62+K81+K100+K119+K138+K157+K176+K195)/(IF(K24=0,0,1)+IF(K43=0,0,1)+IF(K62=0,0,1)+IF(K81=0,0,1)+IF(K100=0,0,1)+IF(K119=0,0,1)+IF(K138=0,0,1)+IF(K157=0,0,1)+IF(K176=0,0,1)+IF(K195=0,0,1))","v":232.96}]